package com.sto.stoapp.db.constant;

public interface UserConstant extends StoBaseConstant {
	public static final String KEY = "key";
	public static final String ROLE = "role";
	public static final String TYPE = "type";
	public static final String BACKUP1 = "backup1";
	public static final String PASS_WORD = "pass_word";

	/**
	 * 用户基本信息表名
	 */
	public static final String USER_TABLE = "user_table";

	/**
	 * 创建用户基本信息表
	 */
	public static final String CREATE_USER_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ USER_TABLE
			+ "("
			+ " id TEXT  "
			+ ","
			+ KEY
			+ " text PRIMARY KEY"
			+ ","
			+ ROLE
			+ " text"
			+ ","
			+ TYPE
			+ " text"
			+ ","
			+ STATUS
			+ " text "
			+ ","
			+ PASS_WORD
			+ " text"
			+ ","
			+ BACKUP1
			+ " text"
			+ ","
			+ VERSION
			+ " text"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE
			+ " char(50)"
			+ ")";
}
